P2Pprogrammer 2 programmer

Home > Download > SMU - Question Paper > BSc IT > BT0066

Database Management Systems


This is the collection of Sikkim Manipal University (SMU) question and answers for Database Management Systems . It will help to prepare your examination. All question paper are classified as per semester, subject code and question type of Part A, Part B and Part C with multiple choice options as same as actual examination. SMU question papers includes year 2025, 2024, 2023 Sem I, II, III, IV, V, VI examinations of all subjects.

SMU question test set of old, last and previous year are updated regularly and it is absolutely free to use. Question paper includes Visual basic 6, VB.Net, C#, ASP.Net, Web, Oracle, Database, SQL, Software Engineering, C, C++, OOPS, MBA, MCA, BSC IT I have requested you kindly send me the question paper of Database Management Systems , SMU - Bachelor of Science in Information Technology.

Course Name        BSc IT (Bachelor of Science in Information Technology)

Subject Code       BT0066 (Database Management Systems )

Get Questions        PART - A    PART - B    PART - C

Subject : Database Management Systems

     BT0066 : PART - C    


Q. 1 What are the features of Magnetic tapes
1. The transfer rate between the device &
memory is at speeds of 50 to 300 KBytes per
second
2. The tape is moved when a read/write
operation is initiated
3. Here the data can be recorded in high
densities
4. A file stored on tape can either be in input
mode or in output mode.
5. The device permits direct access to stored
data by specifying the address of block or
sector containing the data
 A)1, 2,3,4,5
 B)2, 3, 4, 5
 C)1,3,4,5
 D)1, 2, 3, 4
   
Q. 2Give the reason for the popularity of the
client-server architecture?
a) applications distributed data and applications
b) need for graphical user interface for end
users.
c) removes the computing load for presentation
services from the system managing a shared
database resource
d) more powerful workstations on LANs
e) Process share common data structures like
lock table, dead lock detection, scheduling are
performed by an operating system.
 A)a), b), c), d) and e)
 B)a), c) and e)
 C)b), and e)
 D)a), b), c) and d)
   
Q. 3Match the following
SET A
i. Master
ii. Model
iii. Msdb
iv. Tempdb
SET B
a. records all of the system level information for
a SQL Server system
b. is used as the template for all databases
created on a system.
c
 A)i – a, ii – b, iii – c, iv – d
 B)i – b, ii – c, iii – d, iv – a
 C)i – c, ii – d, iii – a, iv – b
 D)i – d, ii – a, iii – b, iv – c
   
Q. 4Match the following types of access
methods with their description
Set A
1. HSAM
2. HISAM
3. HDAM
4. HIDAM
Set B
a. an index based access is permitted for the
root record
b. the random access to root records is
provided using an index.
c. direct access to the root records is provided
using hashing & chaining method
d. child record of a particular parent are stored
consecutively after the parent itself
 A)1 - a, 2 - d, 3 - c, 4 - b
 B)1 - a, 2 - c, 3 - d, 4 - b
 C)1 - d, 2 - b, 3 - c, 4 - a
 D)1 - d, 2 - a, 3 - c, 4 - b
   
Q. 5To locate required block on a track is called
latency time. It is also known as ______
 A)Seek-time
 B)Rotational delay
 C)Rotational Time
 D)Transfer Rate
   
Click here to get Database Management Systems (BT0066 ) New Question


Home > Download > SMU - Question Paper > BSc IT > BT0066